Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
DAYS_TO_CLOSED NUMBER(38) Yes null 22 null NO NO NO
SID NUMBER No null 1 null NO NO NO
OBJ VARCHAR2(20) No null 2 null NO NO NO
ID VARCHAR2(100) No null 3 null NO NO NO
TITLE VARCHAR2(100) No null 4 null NO NO NO
ALLEGATION_CATEGORY VARCHAR2(200) Yes null 5 null NO NO NO
ALLEGATION_SUBCATEGORY VARCHAR2(200) Yes null 6 null NO NO NO
CASE_DISPOSITION VARCHAR2(4000) Yes null 7 null NO NO NO
SUBJECT_ID VARCHAR2(4000) Yes null 8 null NO NO NO
STATUS VARCHAR2(100) Yes null 9 null NO NO NO
OPEN_DATE DATE Yes null 10 null NO NO NO
CLOSED_DATE DATE Yes null 11 null NO NO NO
INV_CLOSED_DATE DATE Yes null 12 null NO NO NO
LEAD_PERSONNEL VARCHAR2(400) Yes null 13 null NO NO NO
SUPPORT_PERSONNEL VARCHAR2(4000) Yes null 14 null NO NO NO
FINAL_DUE_DATE DATE Yes null 15 null NO NO NO
CREATED_DATE DATE Yes null 16 null NO NO NO
CREATED_ON_FY NUMBER Yes null 17 null NO NO NO
DAYS_TO_AWAIT_APPROVAL NUMBER(38) Yes null 18 null NO NO NO
DAYS_TO_OPEN NUMBER(38) Yes null 19 null NO NO NO
DAYS_TO_AWAIT_EMP_REVIEW NUMBER(38) Yes null 20 null NO NO NO
DAYS_TO_INV_CLOSED NUMBER(38) Yes null 21 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 23-AUG-24
LAST_DDL_TIME 07-FEB-25
OWNER QART
VIEW_NAME V_CUBE_TIMES_INVESTIGATIONS
TEXT_LENGTH 5247
TEXT SELECT DISTINCT I.SID, I.OBJ, I.ID, I.SUBJECT TITLE, C.DISPLAY ALLEGATION_CATEGORY, SC.DISPLAY ALLEGATION_SUBCATEGORY, IR.DISPLAY CASE_DISPOSITION, SUB.SUBJECTS SUBJECT_ID, STAT1.STATUS, TRUNC(STAT2.STARTED_ON) OPEN_DATE, TRUNC(STAT3.STARTED_ON) CLOSED_DATE, TRUNC(STAT4.STARTED_ON) INV_CLOSED_DATE, SH1.SH_DISPLAY LEAD_PERSONNEL, SH2.SH_DISPLAY SUPPORT_PERSONNEL, O.FINAL_DUE_DATE, O.CREATED_ON CREATED_DATE,     O.CREATED_ON_FY, (TRUNC(NVL(STAT6.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT5.STARTED_ON, SYSDATE))) DAYS_TO_AWAIT_APPROVAL, (TRUNC(NVL(STAT7.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT6.STARTED_ON, SYSDATE))) DAYS_TO_OPEN, (TRUNC(NVL(STAT8.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT7.STARTED_ON, SYSDATE))) DAYS_TO_AWAIT_EMP_REVIEW, (TRUNC(NVL(STAT9.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT8.STARTED_ON, SYSDATE))) DAYS_TO_INV_CLOSED, (TRUNC(NVL(STAT10.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT9.STARTED_ON, SYSDATE))) DAYS_TO_CLOSED FROM MV_F_INFORMATION I INNER JOIN MV_ACM_OBJ O ON I.OBJ = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID AND OT.OBJ_TYPE_CODE != 'FILE.COLL_INV' LEFT JOIN MV_INCIDENT_CATEGORIES SC              ON I.INCIDENT = SC.SID           LEFT JOIN MV_INCIDENT_CATEGORIES C              ON SC.PARENT_CATEGORY = C.SID           LEFT JOIN MV_CONTRIBUTING_FACTORS F              ON I.CONTRIBUTING_FACTOR = F.SID           LEFT JOIN MV_F_INFORMATION_REF IR              ON I.DISPOSITION = IR.REF_KEY           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_OBJ, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_OBJ) OVER (PARTITION BY OBJ)                                AS SUBJECTS,                             LISTAGG(OFFICE,';' || CHR (13)) WITHIN GROUP ( ORDER BY PARTIC_OBJ ) OVER (PARTITION BY OBJ) AS OFFICE                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON I.OBJ = SUB.OBJ           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS OWNING_AGENCY                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'OWNING_AGENCY') OA              ON I.OBJ = OA.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT1              ON I.OBJ = STAT1.OBJ AND STAT1.COMPLETED_ON IS NULL           LEFT JOIN (  SELECT OBJ,                               MIN (STARTED_ON) STARTED_ON,                               MIN (STARTED_ON_FY) STARTED_ON_FY                          FROM V_OBJ_STATUS_HISTORY                         WHERE CODE = 'OPEN'                      GROUP BY OBJ) STAT2              ON I.OBJ = STAT2.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT3              ON I.OBJ = STAT3.OBJ AND STAT3.CODE LIKE 'CLOSED'   LEFT JOIN (  SELECT OBJ,                               MIN (STARTED_ON) STARTED_ON,                               MIN (STARTED_ON_FY) STARTED_ON_FY                          FROM V_OBJ_STATUS_HISTORY                         WHERE CODE = 'INV_CLOSED'                      GROUP BY OBJ) STAT4              ON I.OBJ = STAT4.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'PRELIM_INVEST' GROUP BY OBJ) STAT5 ON I.OBJ = STAT5.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'APPROVAL' GROUP BY OBJ) STAT6 ON I.OBJ = STAT6.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'OPEN' GROUP BY OBJ) STAT7 ON I.OBJ = STAT7.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'EMP_SPRVSR_REVIEW' GROUP BY OBJ) STAT8 ON I.OBJ = STAT8.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON             FROM V_OBJ_STATUS_HISTORY             WHERE CODE = 'INV_CLOSED'             GROUP BY OBJ) STAT9 ON I.OBJ = STAT9.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON             FROM V_OBJ_STATUS_HISTORY             WHERE CODE = 'CLOSED'             GROUP BY OBJ) STAT10 ON I.OBJ = STAT10.OBJ LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH1              ON I.OBJ = SH1.OBJ AND SH1.CODE = 'LEAD' LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (SH_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY SH_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SH_DISPLAY                        FROM V_CURR_OBJ_STAKEHOLDERS                       WHERE CODE = 'SUPPORT') SH2              ON I.OBJ = SH2.OBJ /* SELECT OBJ, TITLE, CASE WHEN DAYS_TO_AWAIT_APPROVAL < 0 THEN NULL ELSE DAYS_TO_AWAIT_APPROVAL END DAYS_TO_AWAIT_APPROVAL, CASE WHEN DAYS_TO_OPEN < 0 THEN NULL ELSE DAYS_TO_OPEN END DAYS_TO_OPEN, CASE WHEN DAYS_TO_AWAIT_EMP_REVIEW < 0 THEN NULL ELSE DAYS_TO_AWAIT_EMP_REVIEW END DAYS_TO_AWAIT_EMP_REVIEW, CASE WHEN DAYS_TO_INV_CLOSED < 0 THEN NULL ELSE DAYS_TO_INV_CLOSED END DAYS_TO_INV_CLOSED, CASE WHEN DAYS_TO_CLOSED < 0 THEN NULL ELSE DAYS_TO_CLOSED END DAYS_TO_CLOSED FROM STATUS_DAYS; */
TEXT_VC SELECT DISTINCT I.SID, I.OBJ, I.ID, I.SUBJECT TITLE, C.DISPLAY ALLEGATION_CATEGORY, SC.DISPLAY ALLEGATION_SUBCATEGORY, IR.DISPLAY CASE_DISPOSITION, SUB.SUBJECTS SUBJECT_ID, STAT1.STATUS, TRUNC(STAT2.STARTED_ON) OPEN_DATE, TRUNC(STAT3.STARTED_ON) CLOSED_DATE, TRUNC(STAT4.STARTED_ON) INV_CLOSED_DATE, SH1.SH_DISPLAY LEAD_PERSONNEL, SH2.SH_DISPLAY SUPPORT_PERSONNEL, O.FINAL_DUE_DATE, O.CREATED_ON CREATED_DATE,     O.CREATED_ON_FY, (TRUNC(NVL(STAT6.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT5.STARTED_ON, SYSDATE))) DAYS_TO_AWAIT_APPROVAL, (TRUNC(NVL(STAT7.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT6.STARTED_ON, SYSDATE))) DAYS_TO_OPEN, (TRUNC(NVL(STAT8.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT7.STARTED_ON, SYSDATE))) DAYS_TO_AWAIT_EMP_REVIEW, (TRUNC(NVL(STAT9.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT8.STARTED_ON, SYSDATE))) DAYS_TO_INV_CLOSED, (TRUNC(NVL(STAT10.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT9.STARTED_ON, SYSDATE))) DAYS_TO_CLOSED FROM MV_F_INFORMATION I INNER JOIN MV_ACM_OBJ O ON I.OBJ = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID AND OT.OBJ_TYPE_CODE != 'FILE.COLL_INV' LEFT JOIN MV_INCIDENT_CATEGORIES SC              ON I.INCIDENT = SC.SID           LEFT JOIN MV_INCIDENT_CATEGORIES C              ON SC.PARENT_CATEGORY = C.SID           LEFT JOIN MV_CONTRIBUTING_FACTORS F              ON I.CONTRIBUTING_FACTOR = F.SID           LEFT JOIN MV_F_INFORMATION_REF IR              ON I.DISPOSITION = IR.REF_KEY           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_OBJ, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_OBJ) OVER (PARTITION BY OBJ)                                AS SUBJECTS,                             LISTAGG(OFFICE,';' || CHR (13)) WITHIN GROUP ( ORDER BY PARTIC_OBJ ) OVER (PARTITION BY OBJ) AS OFFICE                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON I.OBJ = SUB.OBJ           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS OWNING_AGENCY                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'OWNING_AGENCY') OA              ON I.OBJ = OA.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT1              ON I.OBJ = STAT1.OBJ AND STAT1.COMPLETED_ON IS NULL           LEFT JOIN (  SELECT OBJ,                               MIN (STARTED_ON) STARTED_ON,                               MIN (STARTED_ON_FY) STARTED_ON_FY                          FROM V_OBJ_STATUS_HISTORY                         WHERE CODE = 'OPEN'                      GROUP BY OBJ) STAT2              ON I.OBJ = STAT2.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT3              ON I.OBJ = STAT3.OBJ AND STAT3.CODE LIKE 'CLOSED'   LEFT JOIN (  SELECT OBJ,                               MIN (STARTED_ON) STARTED_ON,                               MIN (STARTED_ON_FY) STARTED_ON_FY                          FROM V_OBJ_STATUS_HISTORY                         WHERE CODE = 'INV_CLOSED'                      GROUP BY OBJ) STAT4              ON I.OBJ = STAT4.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'PRELIM_INVEST' GROUP BY OBJ) STAT5 ON I.OBJ = STAT5.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'APPROVAL' GROUP BY OBJ) STAT6 ON I.OBJ = STAT6.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'OPEN' GROUP BY OBJ) STAT7 ON I.OBJ = STAT7.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'EMP_SPRVSR_REVIEW' GROUP BY OBJ) STAT8 ON I.OBJ = STAT8.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON             FROM V_OBJ_STATUS_HISTORY             WHERE CODE = 'INV_CLOSE
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT